SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 60
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Nestled on 3 private acres in Etna, NH this inviting 4-bedroom, 3-bathroom home offers picturesques water views and a peaceful New Hampshire lifestyle just minutes from Hanover. The landscaped grounds feature mature plantings, open lawn areas, and woodland surroundings that enhance the property’s privacy and charm. Start your mornings on the southeast-facing deck with a cup of coffee while listening to loons call across the water, and enjoy cozy winter days warmed by the pellet stove. Inside, you’ll find a thoughtful blend of comfort and character, including a handsome wood-paneled library, cherry kitchen cabinetry, an indoor sauna, and a newer Jacuzzi soaking tub—perfect for relaxing after a long day. The property provides both privacy and natural beauty with easy acess to Dartmouth College, Dartmouth Health, and all the amenities Hanover, NH has to offer.
Description:"The Rock Ridge Community" Built in 2020 this Colonial style home offers 4 bedroom, 3.5 bath home with extra finished living space in the full walkup basement. Open concept living with hardwood floors, granite counter tops, tiled baths and flexible floor plan. Along with ungraded finishes when purchased owners have landscaped the property with full fencing surround the lot, added a 3 season sunroom off the kitchen plus added over 700 square feet of living space with a finished basement with full bath. Share the community garden, enjoy socials at the Farmhouse, and the privileges that an HOA provides. Close to I89, DHMC, Dartmouth College, Lebanon 6 Movie Theater, Downtown and plenty of shopping. Open House Saturday July 11th 10-12
Description:This West Lebanon gem combines classic comfort with a versatile, modern layout. At the heart of the home, a bright eat-in kitchen with a large island flows naturally into a spacious living room anchored by a cozy fireplace. The second floor offers four bedrooms, including a primary suite with a private bath. For added flexibility, a separate suite above the two-car garage features a kitchenette and built-ins—perfect for guests, a home office, or recreation. Outside, enjoy the quiet neighborhood from the deck or the level, tree-lined backyard. Ideally located, you’re just a quick bike ride from Hanover’s Main Street with easy Advance Transit access to the rest of the Upper Valley. Showings to begin at the Open House on Sunday, March 29th from 1pm to 3pm.
Description:A property for all seasons with waterfront, views, color, comfort and privacy. From the moment you walk into this totally renovated, architecturally designed waterfront home, you will be taken! The floor plan takes advantage of light, efficiency, space and views; includes kitchen, with island crafted of hardwood maple salvaged from a bowling alley in Maine and beautifully refurbished, high-end appliances, dining area, living room and the bedroom where you awaken looking at the River. In addition, there is a laundry area and three-quarter bathroom and a sleeping loft as well as a small area of basement. Not only River frontage but a cove, too, a dock and docking ramps and a Level 2 EV Charger. The owners have been the ultimate stewards of this property; they have had engineers assess the banks and have added structural components not only to better stabilize the banks but to also assure the integrity of the structure of the house. A gem and only minutes to “in town” Hanover!! *‘Renovations were completed in 2022, with design by Daniel Johnson of Watershed Studio Architecture."
Description:Beach Access! Step into timeless elegance with this extraordinary 1929 Classical Revival home, where historic craftsmanship and gracious living come together beautifully. Period details include ornate plaster moldings, stained and beveled glass windows, quarter-sawn oak floors, rich mahogany doors, extra-high ceilings, a sweeping front staircase, and a classic fireplace that creates a warm, dramatic sense of arrival. Offering nearly 5,000 square feet, the home features five bedrooms and six baths, including four ensuite bedrooms for comfort and privacy. Two expansive porches, including a screened porch, overlook spectacular perennial gardens filled with layered plantings, seasonal blooms, and mature landscaping that provide color and fragrance from spring through fall. Pollinator-friendly varieties attract birds and butterflies, while established borders and intimate garden spaces create a serene, park-like setting ideal for morning coffee, sunset gatherings, and evening stargazing. A charming portico and garage add convenience while preserving architectural character. Ideally located in Historic Shaker Village minutes from Dartmouth College and Dartmouth Health, the property offers rare flexibility. Formerly a successful bed and breakfast and now a single-family residence, it is well suited for elegant private living or renewed hospitality use. Enjoy year-round recreation with nearby lake activities, rail trails, and mountain biking, plus easy access to multiple ski areas including Whaleback, Sunapee, Dartmouth Skiway, and Ragged Mountain, with Killington, Stowe, and Loon about an hour away. Completing this remarkable offering is a peaceful, private meditation chapel — a truly unique retreat space that sets this home apart.
Description:Set on 11.5 private acres in scenic Plainfield, New Hampshire, this beautifully designed 2021 home offers the perfect balance of comfort, privacy, and modern living. The main living area is warm and welcoming, centered around a striking stone hearth with a propane fireplace. The bright kitchen opens seamlessly to the living and dining areas, creating an easy flow for everyday living and entertaining. An oversized 2-car garage offers direct entry into the home, while a dedicated laundry room and half bath are conveniently tucked just off the kitchen. A spacious wraparound deck expands the living space outdoors, providing a peaceful setting for summer dining, relaxing, and enjoying the surrounding landscape and water views. The primary suite features a beautifully appointed en suite bath and walk-in closet. The finished lower level offers a large sauna, flexible space for a gym, office, media room, or additional living area. A whole-house generator adds year-round peace of mind. Surrounded by nature yet conveniently located with easy access to Hanover, Lebanon, Shopping, Dartmouth College, and Dartmouth Hitchcock Medical Center, this property offers a wonderful blend of privacy, convenience, and Upper Valley living.
Description:Located just a half mile south of the Dartmouth Green, this beautifully updated raised ranch offers the perfect blend of comfort, flexibility, and convenience. Tucked on a level, landscaped lot with lawn space and landscaping, the home provides an easy lifestyle in a truly exceptional location, walkable to downtown, schools, dining, and recreation. The thoughtfully designed main level features three bedrooms--one ensuite with a 3/4 bath and two that share an additional full bath. Sunlight fills the welcoming living room, while the adjoining dining area opens seamlessly onto a deck - ideal for morning coffee or summer BBQs. The updated kitchen offers both style and functionality, creating a warm central gathering space for everyday living. The finished lower level adds remarkable versatility, with a large family room centered around a cozy wood stove, perfect for relaxing evenings or casual entertaining. A full bath, laundry room, dedicated office, and smaller bonus room provide flexible spaces to work, create, or host guests with ease. Direct access to the attached one-car garage adds everyday convenience, especially during New England winters. With recent updates, abundant usable space, and an unbeatable in-town setting, this move-in-ready home offers the rare opportunity to enjoy comfort, character, and walkability in the heart of Hanover. Furnished photos are virtually staged.
Description:Gorgeous New Hampshire Lakefront! Wake up to breathtaking unobstructed views of Mascoma Lake in this beautifully situated Shaker Village home. Located across from the peaceful Shaker Museum walking grounds, this end-lot offers privacy while still being part of the sought-after Chosen Vale community. Outdoor enthusiasts will love the easy access to boating, swimming, ice fishing, skating, sledding, snowshoeing, hiking trails in the Lower Shaker Wildlife Management Area, and nearby skiing at Whaleback Mountain. This home boasts direct access to a dock slip and is just a short walk to two shared beaches. Additional features include heat pumps, Powerwall backup battery system, electric vehicle charger, and recently installed on-demand boiler. Conveniently located just 15–20 minutes from Dartmouth Hitchcock Medical Center, Dartmouth College, and White River Junction, this property offers the perfect balance of lakeside tranquility and accessibility. Open house Fri 7/10 3-5pm and Sat 7/11 10am-12pm
Description:This beautifully renovated 3-bedroom, 3-bath split-level home offers the perfect blend of modern updates and an unbeatable Hanover location. Thoughtfully redesigned from top to bottom, the property features all-new siding, roof, windows, central air conditioning, and stylishly updated kitchen and baths. Bright, comfortable living spaces and a versatile floor plan make everyday living and entertaining effortless. Set in a sought-after neighborhood within easy walking distance to the highly acclaimed Hanover elementary and middle schools, this turnkey home combines quality, convenience, and timeless appeal.
Description:Nestled in the heart of the charming village of Etna sits this quintessential four bedroom farmhouse that offers a rare blend of historic character, natural beauty and country living. Set on three picturesque acres of pasture, fields and a bordering brook, the property provides a peaceful setting with room to roam, garden or enjoy outdoor recreation. Inside, the home is rich with timeless farmhouse charm, featuring warm hardwood floors, exposed beams, and inviting living spaces that reflect its heritage while offering everyday comfort. The four bedroom layout provides ample space for family, guests, or a home office. Outside, a classic detached barn adds both character and functionality, complete with stalls and plenty of space for hobbies or storage. Meandering paths and trails wind through and around property, inviting exploration and offering opportunities for walking, riding, and enjoying the surrounding landscape. Whether you're seeking a country retreat, a small farm, or a historic New England home with enduring appeal, this Etna farmhouse offers a unique opportunity with close proximity to the Etna Library and Hayes Nature Preserve.